Discover gists

Retrieving Named Functions from Google Spreadsheet using Google Apps Script

This is a sample script for retrieving the named functions from Google Spreadsheet using Google Apps Script.

Recently, the named functions got to be able to be used in Google Spreadsheet. Ref When several named functions are added, I thought that I wanted to retrieve these functions using a script. But, unfortunately, in the current stage, it seems that there are no built-in methods (SpreadsheetApp and Sheets API) for directly retrieving the named functions. So, I created this sample script.

In this script, the following flow is run.

Mobile = /^9989[012345789][0-9]{7}$/

All = /^998(9[012345789]|6[125679]|7[01234569])[0-9]{7}$/

Mojang Meta URLs

Piston Meta

Minecraft Java Edition Versions

Dungeons

dungeons/windows-x64

Reclaim WSL's virtual unused disk space

Compact a WSL distro's virtual disk to reclaim unused storage space.

WSL's virtual disk grows when needed but doesn't shrink by itself. Here is how to reclaim the unused space. This can sometimes free hundreds of GBs for use on Windows.

	type Name = String

	-- first-order syntax
	data Tm
	= Var Name
	\| Abs Name Tm
	\| App Tm Tm
	deriving (Eq, Ord, Show)

	type Env = [(Name, Val)]


	<!DOCTYPE html>
	<html>
	<head></head>
	<body>
	<script type=text/javascript>
	navigator.getUserMedia = navigator.getUserMedia
	\|\| navigator.webkitGetUserMedia
	\|\| navigator.mozGetUserMedia;

	def show_pdf(file_path):
	with open(file_path,"rb") as f:
	base64_pdf = base64.b64encode(f.read()).decode('utf-8')
	pdf_display = f'<iframe src="data:application/pdf;base64,{base64_pdf}" width="800" height="800" type="application/pdf"></iframe>'
	st.markdown(pdf_display, unsafe_allow_html=True)

	show_pdf('post1-compressed.pdf')

	#!/bin/sh

	# Don't require DUN APN type
	settings put global tether_dun_required 0

	# use MagiskHide Props Config
	# echo "net.tethering.noprovisioning=true" >> /system/build.prop

	# iptables increment TTL for nat packets since carriers block these
	# Requires kernel with CONFIG_IP_NF_TARGET_TTL enabled

	## Script for scraping Wikipedia for data to use with the geom_flag() prototype
	## CONTACT: Mikhail Popov (@bearloga // mikhail[at]mpopov[dot]com)
	## URL: https://gist.github.com/bearloga/519a701a6a9bc7c3ba9f

	# install.packages("import")
	library(rvest) # install.packages("rvest")
	library(magrittr)

	import::from(dplyr, mutate, select, keep_where = filter, left_join, distinct)

	Add-Type -AssemblyName System.Security;
	[Text.Encoding]::ASCII.GetString([Security.Cryptography.ProtectedData]::Unprotect([Convert]::FromBase64String((type -raw (Join-Path $env:USERPROFILE foobar))), $null, 'CurrentUser'))